﻿CREATE TABLE [dbo].[RegSchedule] (
    [Id]          INT           IDENTITY (1, 1) NOT NULL,
    [DeptId]      NVARCHAR (50) NULL,
    [DeptName]    NVARCHAR (50) NULL,
    [DoctorId]    NVARCHAR (50) NULL,
    [DoctorName]  NVARCHAR (50) NULL,
    [DoctorTitle] NVARCHAR (50) NULL,
    [TreatTime]   NVARCHAR (50) NULL,
    [RegDate]     NVARCHAR (50) NULL,
    [IsHalt]      NVARCHAR (50) NULL,
    [TimeSlice]   NVARCHAR (50) NULL,
    [StartTime]   NVARCHAR (50) NULL,
    [EndTime]     NVARCHAR (50) NULL,
    [TotalCount]  NVARCHAR (50) NULL,
    [LeaveCount]  NVARCHAR (50) NULL,
    [IsTimeFlag]  NVARCHAR (50) NULL,
    [RegType]     NVARCHAR (50) NULL,
    [Fee]         DECIMAL (18)  NULL,
    [TreatFee]    DECIMAL (18)  NULL,
    [OtherFee]    DECIMAL (18)  NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'主键，自增长', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'Id';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'科室院内编码', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'DeptId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'科室名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'DeptName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'医生院内编码', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'DoctorId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'医生名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'DoctorName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'医生职称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'DoctorTitle';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'医生诊疗平均时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'TreatTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'出诊日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'RegDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否听诊 0 正常出诊 1 停诊', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'IsHalt';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'时段', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'TimeSlice';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'开始时间 HH:MM', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'StartTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'结束时间 HH:MM', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'EndTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'限号数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'TotalCount';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'剩余号数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'LeaveCount';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否有分时', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'IsTimeFlag';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'号类别', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'RegType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'挂号费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'Fee';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'诊疗费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'TreatFee';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'其他费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RegSchedule', @level2type = N'COLUMN', @level2name = N'OtherFee';

